|
![](/i/fill.gif) |
Captain Jack schrieb:
> SELECT C.Name, U.UserName
> FROM tblClients AS C
> OUTER JOIN tblUsers AS U ON U.UserId = C.LastEditUserID
>
> In that case, the column LastEditUserID is zero (another way of logically
> saying Null, I s'pose) when the client row is new and has never been edited.
> I do that so that in that query I always get the client data, with the user
> name being optional.
In theory, you'd solve this by adding another entry to tblUsers with
default values to use for new clients.
Post a reply to this message
|
![](/i/fill.gif) |